

create external table jms_dim.dim_tab_two_configuration_base
(
  total_distance        string COMMENT '总距离里程 (KM)', --NVARCHAR2(30),
  two_forecast_standard bigint COMMENT '二派预估标准' ,
  two_forecast_times   string  comment '二派预估件量时段',
  operate_person        string COMMENT '最后操作人',
  operate_time          timestamp COMMENT '最后操作时间',
  create_time           timestamp COMMENT '插入时间',
  update_time           timestamp COMMENT '更新时间',
  remak                string COMMENT '备注'

)
comment '二派规则配置维护表'
 STORED AS PARQUET
LOCATION
  '/dw/hive/jms_dim.db/external/dim_tab_two_configuration_base'
TBLPROPERTIES (
 'parquet.column.index.access'='true')
